Skip to content
[Jenkins]Jenkins
log in

Failed

Scenario: B11 Broker subscribe on ACL_DATA_ACC is not allowed.Given Mqtt Device is started (from org.eclipse.kapua.service.device.integration.RunBrokerACLI9nTest)

Failing for the past 3 builds (Since #1 )
Took 3 ms.

Error Message

An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.

Stacktrace

org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user!
Caused by: org.apache.shiro.ShiroException: Error while find user!
Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
Caused by: javax.persistence.PersistenceException: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
Caused by: org.eclipse.persistence.exceptions.DatabaseException: 

Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
Caused by: org.h2.jdbc.JdbcSQLException: 
Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]

Standard Output

10:47:46.028 [main] INFO  o.e.k.s.user.steps.UserServiceSteps - Logging out in cleanup
10:47:46.029 [main] INFO  o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - Running database script from resources...
10:47:46.029 [main] INFO  o.e.k.c.jpa.SimpleSqlScriptExecutor - Running resources script: database/all_delete.sql
10:47:46.031 [main] INFO  o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - ...database scripts from resources done!
10:47:46.032 [main] INFO  o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - Running database script from resources...
10:47:46.033 [main] INFO  o.e.k.c.jpa.SimpleSqlScriptExecutor - Running resources script: database/all_delete.sql
10:47:46.035 [main] INFO  o.e.k.c.c.KapuaConfigurableServiceSchemaUtilsWithResources - ...database scripts from resources done!
10:47:46.035 [main] INFO  o.eclipse.kapua.qa.steps.BasicSteps - Wait multiplier active: 4.0
10:47:46.036 [main] INFO  org.eclipse.kapua.qa.steps.DBHelper - Setting up mock database
10:47:46.054 [main] INFO  org.reflections.Reflections - Reflections took 6 ms to scan 12 urls, producing 839 keys and 852 values 
10:47:46.258 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - Executing pre master files...
10:47:46.258 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 	Master Liquibase files found: 3
10:47:46.258 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-authorization-master.pre.xml
10:47:46.291 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-event-store-master.pre.xml
10:47:46.311 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-system-configurations-master.pre.xml
10:47:46.330 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - Executing pre master files... DONE!
10:47:46.330 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - Executing master files...
10:47:46.330 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 	Master Liquibase files found: 10
10:47:46.330 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-account-master.xml
10:47:46.371 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-authentication-master.xml
10:47:46.417 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-authorization-master.xml
10:47:46.513 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-broker-master.xml
10:47:46.574 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-datastore-master.xml
10:47:46.594 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-device-management-master.xml
10:47:46.616 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-device-master.xml
10:47:46.709 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-stream-master.xml
10:47:46.723 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-tag-master.xml
10:47:46.748 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 		Excuting liquibase script: /tmp/genie.kapua/kapua-liquibase/changelog-user-master.xml
10:47:46.790 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - Executing master files... DONE!
10:47:46.790 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - Executing post master files...
10:47:46.791 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - 	Master Liquibase files found: 0
10:47:46.791 [main] INFO  o.e.k.s.l.KapuaLiquibaseClient - Executing post master files... DONE!

  Scenario: B10 Broker create sub-topic on ACL_DATA_ACC is not allowed                                           # features/broker/acl/BrokerACLI9n.feature:173
    Normal user with broker connect profile publishes to topic {0}.foo
    This means that foo topic is not created as broker has no admin rights on this topic.

    Given Mqtt Device is started                                                                                 # AclSteps.startMqttDevice()
      org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
      	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138)
      	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358)
      	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154)
      	at org.eclipse.kapua.service.device.steps.AclSteps.startMqttDevice(AclSteps.java:146)
      	at ✽.Given Mqtt Device is started(features/broker/acl/BrokerACLI9n.feature:176)
      Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user!
      	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85)
      	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269)
      	at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
      	at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
      	at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270)
      	at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256)
      	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138)
      	at org.eclipse.kapua.service.device.steps.AclSteps.startMqttDevice(AclSteps.java:146)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at cucumber.runtime.Utils$1.call(Utils.java:37)
      	at cucumber.runtime.Timeout.timeout(Timeout.java:13)
      	at cucumber.runtime.Utils.invoke(Utils.java:31)
      	at cucumber.runtime.java.JavaStepDefinition.execute(JavaStepDefinition.java:38)
      	at cucumber.runtime.StepDefinitionMatch.runStep(StepDefinitionMatch.java:37)
      	at cucumber.runtime.Runtime.runStep(Runtime.java:299)
      	at cucumber.runtime.model.StepContainer.runStep(StepContainer.java:44)
      	at cucumber.runtime.model.StepContainer.runSteps(StepContainer.java:39)
      	at cucumber.runtime.model.CucumberScenario.run(CucumberScenario.java:44)
      	at cucumber.runtime.junit.ExecutionUnitRunner.run(ExecutionUnitRunner.java:91)
      	at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:63)
      	at cucumber.runtime.junit.FeatureRunner.runChild(FeatureRunner.java:18)
      	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
      	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
      	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
      	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
      	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
      	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
      	at cucumber.runtime.junit.FeatureRunner.run(FeatureRunner.java:70)
      	at cucumber.api.junit.Cucumber.runChild(Cucumber.java:93)
      	at cucumber.api.junit.Cucumber.runChild(Cucumber.java:37)
      	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
      	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
      	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
      	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
      	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
      	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
      	at cucumber.api.junit.Cucumber.run(Cucumber.java:98)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
      	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
      	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
      	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
      Caused by: org.apache.shiro.ShiroException: Error while find user!
      	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103)
      	at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568)
      	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58)
      	... 46 more
      Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
      	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123)
      	at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113)
      	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152)
      	at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118)
      	at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228)
      	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99)
      	at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110)
      	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99)
      	... 48 more
      Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
      SET MODE MySQL://localhost:3306/kapuadb [42000-192]
      Error Code: 42000
      	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815)
      	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
      	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
      	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
      	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
      	at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96)
      	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138)
      	... 53 more
      Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
      SET MODE MySQL://localhost:3306/kapuadb [42000-192]
      Error Code: 42000
      	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
      	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
      	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
      	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
      	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)
      	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)
      	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)
      	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)
      	... 59 more
      Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
      SET MODE MySQL://localhost:3306/kapuadb [42000-192]
      	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
      	at org.h2.message.DbException.get(DbException.java:179)
      	at org.h2.message.DbException.get(DbException.java:155)
      	at org.h2.message.DbException.getSyntaxError(DbException.java:191)
      	at org.h2.command.Parser.getSyntaxError(Parser.java:530)
      	at org.h2.command.Parser.prepareCommand(Parser.java:257)
      	at org.h2.engine.Session.prepareLocal(Session.java:560)
      	at org.h2.engine.Session.prepareCommand(Session.java:501)
      	at org.h2.engine.Engine.openSession(Engine.java:203)
      	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
      	at org.h2.engine.Engine.createSession(Engine.java:137)
      	at org.h2.engine.Engine.createSession(Engine.java:27)
      	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
      	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118)
      	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
      	at org.h2.Driver.connect(Driver.java:72)
      	at java.sql.DriverManager.getConnection(DriverManager.java:664)
      	at java.sql.DriverManager.getConnection(DriverManager.java:208)
      	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
      	... 64 more

    And broker account and user are created                                                                      # AclSteps.createBrokerAccountAndUser()
    When broker with clientId "client-1" and user "luise" and password "kapua-password" is listening on topic "" # AclSteps.connectClientToBroker(String,String,String,String)
    And string "Hello broker" is published to topic "acme/foo" with client "client-1"                            # AclSteps.clientPublishString(String,String,String)
    And 1 second passed for message to arrive                                                                    # BasicSteps.secondsPassed(int)
    Then Broker doesn't receive string "Hello broker" on topic "acme/foo"                                        # AclSteps.brokerDoesntReceiveStringOnTopic(String,String)
    And clients are disconnected                                                                                 # AclSteps.disconnectClientsFromBroker()
    And Mqtt Device is stoped                                                                                    # AclSteps.stopMqttDevice()
10:47:46.802 [ActiveMQ NIO Worker 1] INFO  o.e.k.b.c.p.KapuaSecurityBrokerFilter - User name kapua-sys - client id: ListenerClient, connection id: ID:hipp9-58005-1538664370342-5:25
10:47:46.804 [ActiveMQ NIO Worker 1] INFO  eclipselink.logging.all - EclipseLink, version: Eclipse Persistence Services - 2.6.3.v20160428-59c81c5
10:47:46.805 [ActiveMQ NIO Worker 1] ERROR eclipselink.logging.ejb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
10:47:46.806 [ActiveMQ NIO Worker 1] INFO  o.e.k.b.c.p.KapuaSecurityBrokerFilter - @@ error
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395)
	at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98)
	at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103)
	at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852)
	at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139)
	at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336)
	at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200)
	at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45)
	at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94)
	at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83)
	at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65)
	at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90)
	at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26)
	at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213)
	at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179)
	at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138)
	at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72)
	at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98)
	at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85)
	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269)
	at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
	at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
	at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270)
	at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138)
	... 32 common frames omitted
Caused by: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103)
	at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568)
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58)
	... 38 common frames omitted
Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123)
	at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118)
	at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99)
	at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99)
	... 40 common frames omitted
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
	at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138)
	... 45 common frames omitted
Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)
	... 51 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.message.DbException.getSyntaxError(DbException.java:191)
	at org.h2.command.Parser.getSyntaxError(Parser.java:530)
	at org.h2.command.Parser.prepareCommand(Parser.java:257)
	at org.h2.engine.Session.prepareLocal(Session.java:560)
	at org.h2.engine.Session.prepareCommand(Session.java:501)
	at org.h2.engine.Engine.openSession(Engine.java:203)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
	at org.h2.Driver.connect(Driver.java:72)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
	... 56 common frames omitted
10:47:46.807 [ActiveMQ NIO Worker 1] WARN  o.a.a.broker.TransportConnection - Failed to add Connection id=ID:hipp9-58005-1538664370342-5:25, clientId=ListenerClient due to {}
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395)
	at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98)
	at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103)
	at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852)
	at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139)
	at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336)
	at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200)
	at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45)
	at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94)
	at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83)
	at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65)
	at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90)
	at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26)
	at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213)
	at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179)
	at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138)
	at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72)
	at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98)
	at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85)
	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269)
	at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
	at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
	at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270)
	at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138)
	... 32 common frames omitted
Caused by: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103)
	at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568)
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58)
	... 38 common frames omitted
Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123)
	at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118)
	at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99)
	at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99)
	... 40 common frames omitted
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
	at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138)
	... 45 common frames omitted
Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)
	... 51 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.message.DbException.getSyntaxError(DbException.java:191)
	at org.h2.command.Parser.getSyntaxError(Parser.java:530)
	at org.h2.command.Parser.prepareCommand(Parser.java:257)
	at org.h2.engine.Session.prepareLocal(Session.java:560)
	at org.h2.engine.Session.prepareCommand(Session.java:501)
	at org.h2.engine.Engine.openSession(Engine.java:203)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
	at org.h2.Driver.connect(Driver.java:72)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
	... 56 common frames omitted
10:47:46.813 [ActiveMQ NIO Worker 5] INFO  o.e.k.b.c.p.KapuaSecurityBrokerFilter - User name kapua-sys - client id: ListenerClient, connection id: ID:hipp9-58005-1538664370342-5:26
10:47:46.814 [ActiveMQ NIO Worker 5] INFO  eclipselink.logging.all - EclipseLink, version: Eclipse Persistence Services - 2.6.3.v20160428-59c81c5
10:47:46.816 [ActiveMQ NIO Worker 5] ERROR eclipselink.logging.ejb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
10:47:46.816 [ActiveMQ NIO Worker 5] INFO  o.e.k.b.c.p.KapuaSecurityBrokerFilter - @@ error
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395)
	at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98)
	at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103)
	at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852)
	at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139)
	at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336)
	at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200)
	at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45)
	at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94)
	at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83)
	at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65)
	at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90)
	at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26)
	at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213)
	at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179)
	at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138)
	at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72)
	at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98)
	at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85)
	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269)
	at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
	at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
	at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270)
	at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138)
	... 32 common frames omitted
Caused by: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103)
	at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568)
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58)
	... 38 common frames omitted
Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123)
	at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118)
	at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99)
	at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99)
	... 40 common frames omitted
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
	at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138)
	... 45 common frames omitted
Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)
	... 51 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.message.DbException.getSyntaxError(DbException.java:191)
	at org.h2.command.Parser.getSyntaxError(Parser.java:530)
	at org.h2.command.Parser.prepareCommand(Parser.java:257)
	at org.h2.engine.Session.prepareLocal(Session.java:560)
	at org.h2.engine.Session.prepareCommand(Session.java:501)
	at org.h2.engine.Engine.openSession(Engine.java:203)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
	at org.h2.Driver.connect(Driver.java:72)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
	... 56 common frames omitted
10:47:46.817 [ActiveMQ NIO Worker 5] WARN  o.a.a.broker.TransportConnection - Failed to add Connection id=ID:hipp9-58005-1538664370342-5:26, clientId=ListenerClient due to {}
org.eclipse.kapua.KapuaException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:138)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.handleTokenLoginException(AuthenticationServiceShiroImpl.java:358)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:154)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addExternalConnection(KapuaSecurityBrokerFilter.java:412)
	at org.eclipse.kapua.broker.core.plugin.KapuaSecurityBrokerFilter.addConnection(KapuaSecurityBrokerFilter.java:395)
	at org.apache.activemq.broker.BrokerFilter.addConnection(BrokerFilter.java:98)
	at org.apache.activemq.broker.MutableBrokerFilter.addConnection(MutableBrokerFilter.java:103)
	at org.apache.activemq.broker.TransportConnection.processAddConnection(TransportConnection.java:852)
	at org.apache.activemq.command.ConnectionInfo.visit(ConnectionInfo.java:139)
	at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:336)
	at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:200)
	at org.apache.activemq.transport.MutexTransport.onCommand(MutexTransport.java:45)
	at org.apache.activemq.transport.mqtt.MQTTInactivityMonitor.onCommand(MQTTInactivityMonitor.java:162)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.sendToActiveMQ(MQTTTransportFilter.java:106)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.sendToActiveMQ(MQTTProtocolConverter.java:181)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTConnect(MQTTProtocolConverter.java:310)
	at org.apache.activemq.transport.mqtt.MQTTProtocolConverter.onMQTTCommand(MQTTProtocolConverter.java:205)
	at org.apache.activemq.transport.mqtt.MQTTTransportFilter.onCommand(MQTTTransportFilter.java:94)
	at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:83)
	at org.apache.activemq.transport.mqtt.MQTTCodec$1.onFrame(MQTTCodec.java:65)
	at org.apache.activemq.transport.mqtt.MQTTCodec.processCommand(MQTTCodec.java:90)
	at org.apache.activemq.transport.mqtt.MQTTCodec.access$400(MQTTCodec.java:26)
	at org.apache.activemq.transport.mqtt.MQTTCodec$4.parse(MQTTCodec.java:213)
	at org.apache.activemq.transport.mqtt.MQTTCodec$3.parse(MQTTCodec.java:179)
	at org.apache.activemq.transport.mqtt.MQTTCodec$2.parse(MQTTCodec.java:138)
	at org.apache.activemq.transport.mqtt.MQTTCodec.parse(MQTTCodec.java:76)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.processBuffer(MQTTNIOTransport.java:132)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.serviceRead(MQTTNIOTransport.java:120)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport.access$000(MQTTNIOTransport.java:43)
	at org.apache.activemq.transport.mqtt.MQTTNIOTransport$1.onSelect(MQTTNIOTransport.java:72)
	at org.apache.activemq.transport.nio.SelectorSelection.onSelect(SelectorSelection.java:98)
	at org.apache.activemq.transport.nio.SelectorWorker$1.run(SelectorWorker.java:118)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.shiro.authc.AuthenticationException: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:85)
	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:269)
	at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198)
	at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106)
	at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:270)
	at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:256)
	at org.eclipse.kapua.service.authentication.shiro.AuthenticationServiceShiroImpl.login(AuthenticationServiceShiroImpl.java:138)
	... 32 common frames omitted
Caused by: org.apache.shiro.ShiroException: Error while find user!
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:103)
	at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568)
	at org.eclipse.kapua.service.authentication.shiro.KapuaAuthenticator.doMultiRealmAuthentication(KapuaAuthenticator.java:58)
	... 38 common frames omitted
Caused by: org.eclipse.kapua.KapuaException: An internal error occurred: Error during Persistence Operation.
	at org.eclipse.kapua.KapuaException.internalError(KapuaException.java:123)
	at org.eclipse.kapua.commons.util.KapuaExceptionUtils.convertPersistenceException(KapuaExceptionUtils.java:113)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:152)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.onResult(EntityManagerSession.java:118)
	at org.eclipse.kapua.service.user.internal.UserServiceImpl.findByName(UserServiceImpl.java:228)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.lambda$doGetAuthenticationInfo$0(UserPassAuthenticatingRealm.java:99)
	at org.eclipse.kapua.commons.security.KapuaSecurityUtils.doPrivileged(KapuaSecurityUtils.java:110)
	at org.eclipse.kapua.service.authentication.shiro.realm.UserPassAuthenticatingRealm.doGetAuthenticationInfo(UserPassAuthenticatingRealm.java:99)
	... 40 common frames omitted
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:815)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
	at org.eclipse.kapua.commons.jpa.AbstractEntityManagerFactory.createEntityManager(AbstractEntityManagerFactory.java:96)
	at org.eclipse.kapua.commons.jpa.EntityManagerSession.internalOnResult(EntityManagerSession.java:138)
	... 45 common frames omitted
Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)
	... 51 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.message.DbException.getSyntaxError(DbException.java:191)
	at org.h2.command.Parser.getSyntaxError(Parser.java:530)
	at org.h2.command.Parser.prepareCommand(Parser.java:257)
	at org.h2.engine.Session.prepareLocal(Session.java:560)
	at org.h2.engine.Session.prepareCommand(Session.java:501)
	at org.h2.engine.Engine.openSession(Engine.java:203)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:118)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
	at org.h2.Driver.connect(Driver.java:72)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
	... 56 common frames omitted
10:47:48.808 [ActiveMQ BrokerService[message-broker] Task-3] INFO  o.a.a.broker.TransportConnection - Stopping tcp://127.0.0.1:47621 because Failed with SecurityException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
10:47:48.818 [ActiveMQ BrokerService[message-broker] Task-1] INFO  o.a.a.broker.TransportConnection - Stopping tcp://127.0.0.1:47622 because Failed with SecurityException: An internal error occurred: org.apache.shiro.ShiroException: Error while find user!.
10:47:51.822 [main] INFO  eclipselink.logging.all - EclipseLink, version: Eclipse Persistence Services - 2.6.3.v20160428-59c81c5
10:47:51.824 [main] ERROR eclipselink.logging.ejb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SET MODE MYSQL:[*]                       b "; SQL statement:
SET MODE MySQL://localhost:3306/kapuadb [42000-192]
Error Code: 42000

Standard Error

Broker unavailable (3)
	at org.eclipse.paho.client.mqttv3.internal.ExceptionHelper.createMqttException(ExceptionHelper.java:31)
	at org.eclipse.paho.client.mqttv3.internal.ClientState.notifyReceivedAck(ClientState.java:990)
	at org.eclipse.paho.client.mqttv3.internal.CommsReceiver.run(CommsReceiver.java:118)
	at java.lang.Thread.run(Thread.java:748)